package com.itheima.health.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.health.pojo.Member;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface MemberMapper extends BaseMapper<Member> {
                                 //预约表
    @Select("select count(1) from t_order where  MEMBER_ID = #{id} and ORDERDATE = #{day} and SETMEAL_ID = #{tid}")
    int isOrderDayByMemberIdBySetmealId(@Param("day") String day ,@Param("id") Integer id ,@Param("tid") Integer tid); //日期  用户id  套餐id

}
